Write Cell
AutomatR.GoogleSheets.Activities.WriteCell
The "Write Cell" activity in AutomatR is part of the Google Sheets activities package, designed to write a specified value into a cell within a Google spreadsheet. This activity simplifies the process of updating cell values in Google Sheets, enhancing the efficiency of automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Cell Address | Specifies the cell location on the spreadsheet where the value should be written (e.g., A1). String variables containing the cell address. |
| Value | Specifies the content that should be written into the specified cell. String variables containing the content to be written. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Write Cell" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Outputs the result of the "Write Cell" operation, indicating whether the cell write was successful or encountered errors. Variables of relevant types (e.g., Boolean variables) to store the operation result. |
How to use:
- Drag and drop the "Write Cell" activity onto the workflow.
- Configure the properties by specifying the cell address and the value to be written.
- Optionally, configure the delay.
- Place the "Write Cell" activity within a "Google Sheets App Scope" to ensure proper authentication and access to the Google Sheets service.
- Execute the workflow to write the specified value into the designated cell in the Google spreadsheet.
Example: Consider an example where the "Write Cell" activity is used to write the value "100" into cell "A1" within a Google spreadsheet:
Write Cell:
Cell Address: "A1"
Value: "100"
Delay: 1
Result: isWriteSuccessful
In this example, the activity writes the value "100" into cell "A1" of the Google spreadsheet. The result of the operation (success or failure) is stored in the Boolean variable "isWriteSuccessful" for further handling in the workflow.